package com.example.drug.jpa;

import java.util.List;

import com.example.common.entity.MsgConfig;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

public interface MsgConfigRepository extends JpaRepository<MsgConfig, String> {
    
    @Query(value = "SELECT template_id_nvarchar FROM sys_msg_config WHERE m_type_tinyint = 4",nativeQuery = true)
    List<String> findByType();
}
